﻿<%@ Page Title="Rule Execution Result" Language="C#" MasterPageFile="~/Site.Master"
    AutoEventWireup="true" CodeBehind="RuleExecutionResult2.aspx.cs" Inherits="TestJQGrid.RuleExecutionResult2" %>

<%@ Register Assembly="Trirand.Web" Namespace="Trirand.Web.UI.WebControls" TagPrefix="Trirand" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
    <!-- The jQuery UI theme that will be used by the grid -->
    <link rel="stylesheet" type="text/css" media="screen" href="../themes/redmond/jquery-ui-1.8.2.custom.css" />
    <!-- The jQuery UI theme extension jqGrid needs -->
    <link rel="stylesheet" type="text/css" media="screen" href="../themes/ui.jqgrid.css" />
    <!-- jQuery runtime minified -->
    <script src="../js/jquery-1.4.4.min.js" type="text/javascript"></script>
    <!-- The localization file we need, English in this case -->
    <script src="../js/trirand/i18n/grid.locale-en.js" type="text/javascript"></script>
    <!-- The jqGrid client-side javascript -->
    <script src="../js/trirand/jquery.jqGrid.min.js" type="text/javascript"></script>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <table>
        <tr style="height: 50%; width: 100%;">
            <Trirand:JQGrid runat="server" ID="JQGridAgent" AutoWidth="True" DataSourceID="SqlDataSource1">
                <Columns>
                    <Trirand:JQGridColumn DataField="AgentId" />
                    <Trirand:JQGridColumn DataField="AgentName" />
                    <Trirand:JQGridColumn DataField="RuleName" />
                    <Trirand:JQGridColumn DataField="CycleStartDate" DataType="System.DateTime" DataFormatString="{0:dd/MM/yyyy}" />
                    <Trirand:JQGridColumn DataField="CycleEndDate" DataType="System.DateTime" DataFormatString="{0:dd/MM/yyyy}" />
                    <Trirand:JQGridColumn DataField="Amount" />
                    <Trirand:JQGridColumn DataField="Status" />
                    <Trirand:JQGridColumn DataField="Taxes" />
                </Columns>
                <ToolBarSettings ShowRefreshButton="True" ShowSearchButton="True" />
                <SearchDialogSettings MultipleSearch="true" />
                <SortSettings InitialSortColumn="AgentId"></SortSettings>
                <AppearanceSettings ShrinkToFit="false" />
            </Trirand:JQGrid>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:AgentBillingConnectionString %>"
                SelectCommand="SELECT [AgentId], [AgentName], [RuleName], [CycleStartDate], [CycleEndDate], [Amount], [Status], [Taxes] FROM [demo_payout]">
            </asp:SqlDataSource>
            <td>
            </td>
        </tr>
        <tr style="height: 50%; width: 100%;">
            <td>
                <Trirand:JQGrid runat="server" ID="JQGridTrans" AutoWidth="True" DataSourceID="SqlDataSource2">
                    <Columns>
                        <Trirand:JQGridColumn DataField="TransId" />
                        <Trirand:JQGridColumn DataField="RuleName" />
                        <Trirand:JQGridColumn DataField="SubRule" />
                        <Trirand:JQGridColumn DataField="SlabName" />
                    </Columns>
                    <ToolBarSettings ShowRefreshButton="True" ShowSearchButton="True" />
                    <SearchDialogSettings MultipleSearch="true" />
                    <SortSettings InitialSortColumn="TransId"></SortSettings>
                    <AppearanceSettings ShrinkToFit="false" />
                </Trirand:JQGrid>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:AgentBillingConnectionString %>"
                    SelectCommand="SELECT [TransId], [RuleName], [SubRule], [SlabName] FROM [demo_transdetails]">
                </asp:SqlDataSource>
            </td>
        </tr>
    </table>
</asp:Content>
